SQL and Entity Beans

[Stedo]

hi,

I'm writing a J2EE app and I want to interface with a database. I've been looking at Entity beans and all is well. However what I want to do is simply execute an SQL statement and get a vector of strings back.

Do I have to use Entity Beans to do this? I have tried writing a finder function but on deployment I am told that finder functions can only return primary keys or collections of primary keys. Is there another way.

Thanks
Steve

 

[Diancecht]

I'm not sure about what a finder function is, but if you just want to connect to a database, you may not need a Bean, a JDBC connection can be enough.

Cheers,
Dian

 

[Stedo]

hi,

If I don't connect to the database through a bean what do I connect to the database through?

Thanks
Steve

 

[Diancecht]

As I said before, JDBC may be your answer.

There's a tutorial at

http://java.sun.com/docs/books/tutorial/jdbc/

or you can search this forum or the Java forum for examples.

Cheers,
Dian

 

[Stedo]

hi,

Okay, I figured it out, I can just use normal session beans with a local interface to connect to the database.

Thanks
Steve