This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 100550 - jdbc pool properties for different databases has incorrect pre-defined values
Summary: jdbc pool properties for different databases has incorrect pre-defined values
Status: RESOLVED FIXED
Alias: None
Product: serverplugins
Classification: Unclassified
Component: Sun Appserver 9 (show other bugs)
Version: 5.x
Hardware: Other All
: P3 blocker (vote)
Assignee: Nitya Doraisamy
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-04-10 23:44 UTC by ngap
Modified: 2008-02-29 06:02 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description ngap 2007-04-10 23:44:57 UTC
NetBeans IDE 5.5.1 daily build 200703210600 
Java EE sdk build 5 Update 3 preview2-b10

I think for each type of database, appserver used different fields. For
instance, oracle will require user,password and url while sybase requires
serverName, databaseName,db port,user,password. I looks through the jdbc pool
creation screens and it seems almost all databases are using url, user, and
password. 

Below is a list of things that are incorrect:

1)IBM DB2 7.1
Datasource Classname should be com.ibm.db2.jdbc.DB2DataSource rather than
com.ibm.db2.jcc.DB2DataSource

Pre-defined value of URL property is not correct. 

2)Sun DataDirect driver for db2, microsoft, oracle
Pre-defined value of URL property is not correct. Currently it has this format
for all types of databases:
      jdbc:db2://<HOST>:<PORT>/<DB>

Probably it should have this format jdbc:sun:db2://<HOST>:<PORT>;databaseName=<DB>
jdbc:sun:sybase://<HOST>:<PORT>;SID=<DB_SID>
jdbc:sun:sqlserver://<HOST>:<PORT>;SID=<DB_SID>

3)Postgres has incorrect URL value
jdbc:db2://<HOST>:<PORT>/<DB>
 
Maybe it should be:
jdbc:postgresql://<HOST>/<DB>:<PORT>

4)Microsoft SQL Server JDBC Driver has incorrect URL value 
jdbc:db2://<HOST>:<PORT>/<DB>

Maybe it should be:
jdbc:sqlserver://<HOST>

5)jTDS has has incorrect URL value 
jdbc:db2://<HOST>:<PORT>/<DB>


6) Java DB (net) has incorrect User value

jdbc:db2://<HOST>:<PORT>/<DB>

It should be blank for this field

Do we need other fields such as DatabaseName, serverName, etc ?


7) Pointbase currently has user, password, databaseName properties names

does it take a URL ? will it work with just those field listed above ?
we use  a URL such as jdbc:pointbase:server://<HOST>:<PORT>/<DB>,new
Comment 1 Nitya Doraisamy 2007-04-10 23:51:24 UTC
Will be done as part of wizard cleanup
Comment 2 Vince Kraemer 2007-12-07 16:18:51 UTC
please close this issue if you forgot to earlier.  If this issue is still open,
please change the target milestone to reflect the current commitment.
Comment 3 Nitya Doraisamy 2008-02-29 05:55:10 UTC
This was done as part of the wizard cleanup. Overlooked closing the IZ
Comment 4 Nitya Doraisamy 2008-02-29 06:02:54 UTC
see comment above