Is DB2 6.1 Type 2 JDBC Driver Supported ?
Hi,
I'm trying to drag and drop a simple database table on a dropdown control, so far it worked with the DISCOUNT_CODE table from the Sample Derby database, but I cannot make it work with a DB2 6.1 database, even though the database is properly connected and I can display the table data from Netbeans.
In fact, the properties of the connection pool resource generated by Netbeans when I drag and drop that table on the drop down don't even ping to the database if I try from the Admin Consoe. I managed to make it ping using the proper property values, but I'm not able to correctly bind data to the control after that.
Any ideas ? Thanks in advance !!
Daniel
[694 byte] By [
toffedana] at [2007-11-26 14:29:09]
# 1
More on this issue:
I don't know if this can help, when I try to ping the connection pool in the Admin Console I get this in the server.log:
[#|2007-01-08T18:34:00.296-0300|INFO|sun-appserver-pe9.0
|javax.enterprise.resource.resourceadapter
|_ThreadID=17;_ThreadName=httpWorkerThread-4848-4;|DAS CONTEXT IS :
Description <null>
ElementProperty[5]#0:
Description <null>
attr: Name=serverName attr: Value=MYSRV#1:
Description <null>
attr: Name=portNumber attr: Value=MYPORT#2:
Description <null>
attr: Name=Passwordattr: Value=MYPASS#3:
Description <null>
attr: Name=Userattr: Value=MYUSER#4:
Description <null>
attr: Name=databaseName attr: Value=MYDB|#]
The ping doesn't return even an error message.
Daniel
# 3
Thanks for your reply, I managed to properly set all properties and the ping succeeded, but now I have another two problems:
- When I redeploy the project, the connection pool properties are turned back to what Netbeans wants to set them, and that just don't work.for example it sets the property serverName to 'dbc' which is not the name of my server, and also has a property 'portNumber', which should be just 'port'. So I have to change them manually every time.
- When I try to 'Bind to Data', the Data Provider is turned to red, as if it were invalid, so I can't assign the table fields.
I guess perhaps it has something to do with the old JDBC driver... ? It has a timestamp of May 2002...
Any ideas ? Thanks in advance,
Daniel
# 4
helloIm not very fond of netbeans, but try and load the connection which pings in the admin console, try and load it to netbeans, in replace for the old connection which you loaded in netbeans.eve
