Frequently Asked Questions

• What are the system requirements?
• What are the supported database systems?
• What are the supported J2EE or servlet containers?
• What are the supported Web browsers?
• Where to get the SQL Server 2000/2005 JDBC driver?
• Where to get the SQL Server 2000 JDBC driver (obsolete)?
• Where to get the Oracle JDBC driver?
• What jdbc driver should I use for DB2?
• Can Bugzero be installed in a virtual host environment?
• Can I run Tomcat as an NT service for Bugzero (on windows)?
• What is the HTTP port number of my application server?
• How to deploy Bugzero on IBM WebSphere 4.x?

• How can I add more user groups?
• Can Bugzero cc email to people?
• The hype-link in the bug notification email does not work.
• How can I always send notification email to the original submitter?
• I do not have a SMTP mail server, can I disable sending email?
• Are there any restrictions for the project ID?
• Can I change the project name of an existing project?
• Does Bugzero accept bug reports submitted through email?
• Can Bugzero be integrated with CVS source control system?
• Can Bugzero be integrated with Subversion source control system?
• Can Bugzero be integrated with Perforce?
• Can Bugzero be used for IT help desk customer support?
• Does Bugzero support internationalization?
• The #ID number is not continuous, it jumps sometimes, why?
• Can Bugzero be deployed in a clustering environment?

• Reports: The graphic report failed to be displayed and exceptions occurred.
  "... Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable"

• Email Notification: Why email notification is not sent, and what are these JavaMail Exceptions?
  (SecurityException, NoSuchProviderException, NoClassDefFoundError)

• Email Notification: SMTP server connectivity problem due to anti-virus software
  

• Email Notification: Why is it in garbled HTML code?

• Email Submission with gif of jpg attachment: Graphics support in JavaMail
  

• JavaMail NPE: For both email notification and incoming email on Ubuntu Linux
  

• Installation with MySQL: With MySQL, at the step of "Creating Tables" during setup , I got
  java.sql.SQLException: Server connection failure during transaction. Attempted reconnect 3 times. Giving up.

• Installation with Solaris: I got this Exception on Solaris during setup, how to fix it?
  java.lang.InternalError: Unsupported 16-bit depth

• Unix Installation: On Unix (Linux), login failed because of the file write permission.

• Unix File Permission: When login, I got the following exception:
  java.lang.NoClassDefFoundError at com.websina.bean.Person.login(Person.java)

• Session and Cookie: After I login, it takes me to the same page, what is going on?

• Caching: When I switch project, it always fall back to the HOME page and display the bug list of the previous project.

• JDBC-ODBC: What is this JDBC-ODBC Exception?
  [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index

• Oracle: What is this java.sql.SQLException: ORA-01467: sort key too long?

• IBM DB2: What is this COM.ibm.db2.jdbc.DB2Exception?
  [IBM][JDBC Driver] CLI0616E Error opening socket. SQLSTATE=08S01

• DB2 Driver Bug: What is this COM.ibm.db2.jdbc.DB2Exception?
  [IBM][JDBC Driver] CLI0637E QUERY cannot be found

• IBM AS400 Database SQLCODE: SQL7008 when updating table

• File Attachment - MySQL: With MySQL, when attaching a file, I got
  java.lang.IllegalArgumentException: Packet is larger than max_allowed_packet from server configuration of 1048576 bytes

• MySQL: Table is full error

• MySql timeout error: With MySQL, after a long time of in-activity, I got
  java.sql.SQLException: Communication link failure: java.net.SocketException.

• MySQL SQLException: Cannot convert value '0000-00-00 00:00:00' to TIMESTAMP

• MySql stack overflow error: With MySQL, I got java.lang.StackOverflowError.

• MySQL 4: utf8 charset support.

• Installation - Sybase: error when creating tables and create the admin user during setup:
  The column default_project in table person does not allow null values.

• Upgrade: SQL Server: error when changing database schema:
  [SQLServer]Invalid object name 'bugzero_db.dbo.UpdateLog'

• Sybase: error when dropping/creating tables:
  ... command not allowed within multi-statement transaction in the ... database.

• Blank page - Tomcat: I am using Tomcat 4.1.14, when run Bugzero, sometimes I got a blank page. What happened?

• Tomcat zip file: Is there a potential zip file classloading problem with Tomcat?

• Tomcat: With Tomcat, when login, I got an error:
  Unable to compile class for JSP ... package com.websina.bean does not exist

• Tomcat: With Tomcat, uwhen login, I got an error:
  \work\Standalone\localhost\_\bugzero\jsp\login_jsp.java:35: package com.websina.util does not exist

• Tomcat: unable to find a javac compiler.

• Tomcat java.lang.IllegalStateException: Parameter count exceeded allowed maximum: 512

• Blank page - Tomcat: I am using Tomcat 4.1.14, when run Bugzero, sometimes I got a blank page. What happened?

• Tomcat/Linux RedHat 9: Why does tomcat hang after starting on a Linux machine?

• Tomcat: Tomcat did not decode the uri (particularly the file download link) correctly, why?

• Classpath: When login, I got
  Cannot create connection pool, check log for detail

• Classpath: When login, I got
  Failed to read sql file: login_person

• Attach large files or run search with large result set: OutOfMemoryError

• File Attachment:
  Database error attatching Miscrsoft office 2007 files

• Email submission with large attachment, email not saved: OutOfMemoryError

• Email Submission: Null pointer exception in JavaMail 1.2
  

• Mailbox: All mailboxes suddenly disappeared

• Unable to compile class for JSP: java.io.FileNotFoundException

• WAS 5 (WebSpere): unable to compile class for JSP: org.apache.jasper.compiler.ParseException: Attribute has no value

• LDAP: Microsoft Active Directory error code 2 - Protocol Error

• LDAP: Microsoft Active Directory error code 49

• F5 BigIP: Timeout issues over https using F5 BigIP

• The setup program hangs.
• How to install and use Microsoft SQL Server 2000 with Bugzero?
• How to create an ODBC data source (DSN)?
• How to install and run MySQL on Microsoft Windows?
• Which PostgreSQL binary data type can Bugzero use?
• Which Oracle binary data type can Bugzero use?
• Which Oracle long text data type can Bugzero use?
• When to use parallel query with Oracle database?
• Can the Microsoft SQL Server 2000 JDBC driver be used on SQL Server 7?
• How accurate is the datetime in Bugzero?
• Why the SecureRandom generateSeed is so slow or even hang on Linux OS?

• JavaMail properties (package java.mail)
• JavaMail properties (package com.sun.mail)
• LDAP properties (from com.sun)
• Networking properties (package com.sun.mail)
• Oracle database connection problem
• Form submission error with IE 6 (empty post data)
• Java Applet, cookie, and session lost issues
• Install WebSphere 4 on Windows 2000 with Oracle 8i
• Install WebSphere HTTP transport custom properties
• Unicode, UTF-8, UTF-16, and BOM
• Unicode ISO 8859-1 Characters List
• PostgreSQL database server charset and JDBC URL
• Microsoft SQL Server Datetime and the Convert function
• Microsoft SQL Server authentication methods
• JavaScript Functions
• Regular Expressions
• Java Applet Issues
• Java Encodings and Charset
• Country ISO 3166 Codes
• Language ISO 3166 Codes
• How to open file links (file://-URLs) in a webpage (http://-URLs)

• HTTP java.net.SocketException: Connection reset by peer: socket write error
• Oracle SQLException: No more data to read from socket
• SQL Server JDBC Connection Error: Error establishing socket, connection refused...
• WebSphere: An error occurred while parsing parameters: Async operation timed out
• Apache file upload error with https: read timed out